Previous Topic

Next Topic

To enter a SQL verification calculation

If you enter a SQL Registration Verification Calculation, iMIS tests a registrant's eligibility based on the requirements defined in the calculation. The SQL calculation results in either a 1 or a 0. If the result is a 1, then iMIS enables you to create an order for the registrant. If the result is a 0, then a message is displayed indicating that the registrant is not eligible, and the registration is canceled.

  1. From Events, select Define an event, double-click an event, click More, and select Notes to open the Event Notes window.
  2. Click Edit.
  3. Enter a verification calculation in the SQL Registration Verification Calculation (Optional) field.

    The following is a sample calculation (the calculation varies from organization to organization). The sample calculation searches for all CM (company member) types, and, if the registrant is not a CM, iMIS displays a message indicating that the registration cannot be processed.

    select COUNT(*) from Name where MEMBER_TYPE='CM' and ID = [AsiSQL(Orders.ST_ID)]
  4. Click Save.
  5. Restart iMIS.

See Also

Entering Event Coordinators and Notes

Event Coordinators window

To enter event coordinator information

To enter event notes


ASI logo 10.6 Production Release. Updated 1/12/2006 4:31:48 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.